SELECT *, CASE WHEN `name` LIKE "lake placid%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lake placid" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lake placid" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lake placid" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "NY" AND (locality IN ("lake placid") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$15,000,000116 Bear Cub LnLake Placid NY 12946View Listing
$11,800,00014 Yacht Club WayLake Placid NY 12946View Listing
$8,100,000193 Ruisseaumont WayLake Placid NY 12946View Listing
$3,400,00012 George Bliss Ln # 509/510Lake Placid NY 12946View Listing
$3,200,00067 Sugarworks WayLake Placid NY 12946View Listing
$3,200,000229 Roaring Brook WayLake Placid NY 12946View Listing
$1,895,000190 Stevens RdLake Placid NY 12946View Listing
$1,795,000185 Algonquin DrLake Placid NY 12946View Listing
$1,695,000489 Bear Cub RdLake Placid NY 12946View Listing
$1,425,000241 Algonquin DrLake Placid NY 12946View Listing
$1,350,000313 Mount Whitney WayLake Placid NY 12946View Listing
$1,250,000Beech Ldg Lot 17BLake Placid NY 12946View Listing
$1,200,00058 Garden Way Unit BEAVER4Lake Placid NY 12946View Listing
$1,150,00040 Saddle Back WayLake Placid NY 12946View Listing
$1,150,00033 Edgley WayLake Placid NY 12946View Listing
$1,095,00010 Emelies WayLake Placid NY 12946View Listing
$999,000569 Mirror Lake DrLake Placid NY 12946View Listing
$999,0004862 Cascade RdLake Placid NY 12946View Listing
$999,000Maple Ldg Lot 19ALake Placid NY 12946View Listing
$995,00068 Garden Way Unit RACCOON4Lake Placid NY 12946View Listing
$975,00012 Fox Run LnLake Placid NY 12946View Listing
$935,00073 Evans LnLake Placid NY 12946View Listing
$925,00066 Long Pond TrlLake Placid NY 12946View Listing
$925,00056 Long Pond TrlLake Placid NY 12946View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-09-2024 4:26:03 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah